UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'l6EiZdibJ4+Zyj0OZdkkwal4dYNGbZRR9zzrLoZHp7w='
WHERE
key_id = '04510f39fa86f3e715b457a702f75440a97f5faab41db52ad178abf514b6e5a9'
AND (
token = 'l6EiZdibJ4+Zyj0OZdkkwal4dYNGbZRR9zzrLoZHp7w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)