UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lWbQiSpxDz6XZ6I2nf6ybmh5w/ZSNapEjnkncRWZ7pk='
WHERE
key_id = '5d9a52d2be56489d667e2a3ddf73b2a2bdb64ef7f6d9e436f316268a98e70baa'
AND (
token = 'lWbQiSpxDz6XZ6I2nf6ybmh5w/ZSNapEjnkncRWZ7pk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)