UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BjTC/C9NsDn7mV1STx1bJgVZUTDuLWVN28KoWZdJjMY='
WHERE
key_id = '0f1c3b716fe505c4310ef6813a2591e550667553da86f81b80c0d15e1dd75628'
AND (
token = 'BjTC/C9NsDn7mV1STx1bJgVZUTDuLWVN28KoWZdJjMY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)