UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nOYjTfKCljz50PAZoFw741Omi1x4AcAiX6zxBdtawc0='
WHERE
key_id = 'd09ae0b20bec1226cf5735b4f5cd5798415147e4d82a4351f730087b4fdd21f9'
AND (
token = 'nOYjTfKCljz50PAZoFw741Omi1x4AcAiX6zxBdtawc0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)