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