UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jT21giIqZmvsV8L84aAydFw5NUyz901HXBA4vpXh/Cw='
WHERE
key_id = 'ffc29c213a9d13cc2cf0626ef16327c40eb60cdae40303d73a8bb1bb0ed3a846'
AND (
token = 'jT21giIqZmvsV8L84aAydFw5NUyz901HXBA4vpXh/Cw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)