UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7CBwEGHealux5CY2HR4OqpI58tjbjrg1Srk8HF7eR48='
WHERE
key_id = '86c0406679c978623051248a58fdd9ed1f262b6202ec0812bbede0706fe03fb6'
AND (
token = '7CBwEGHealux5CY2HR4OqpI58tjbjrg1Srk8HF7eR48='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)