UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6SJ1i6vhaLsgUPYSvNag6Wm63NXGlwev4ELfo5rXCG0='
WHERE
key_id = 'a0b0e9435ba107387a5fab3692597f6f6c0a1c5fcefb815da7d7ff3e8f9d104b'
AND (
token = '6SJ1i6vhaLsgUPYSvNag6Wm63NXGlwev4ELfo5rXCG0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)