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