UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RKuuOcVFFHqSz7UfeoUkZxRX6Vl0HPmRWRYMUQEQ/Yk='
WHERE
key_id = '7fc2765786f11b78493d6d7bd2e45d9587af0016b4c3892b43c8f0b3e2c8fb59'
AND (
token = 'RKuuOcVFFHqSz7UfeoUkZxRX6Vl0HPmRWRYMUQEQ/Yk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)