UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'prWA2+HYYnrBDu9brQE2/I2HRygBP42BF7vRnDmPUkQ='
WHERE
key_id = '6c80de32d40047a143d573e30c3d5aec3582c44aabebf55ec49a3eeaaf6cad6a'
AND (
token = 'prWA2+HYYnrBDu9brQE2/I2HRygBP42BF7vRnDmPUkQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)