UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'smqMmMkQigjNHj+T+MENMZC7vF6SQRIEjBbPNMVnD+U='
WHERE
key_id = 'a3c61449316f46f98120e0bd21d2f3d1d0a1a624d142ca6938ff92aee4bb3271'
AND (
token = 'smqMmMkQigjNHj+T+MENMZC7vF6SQRIEjBbPNMVnD+U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)