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