UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gdlXKYl/5vqAhrRwC6neR5XvyKSrcehRhp92D0Kbuc4='
WHERE
key_id = 'a1c1caf29a7bb3a6c8ff6914bcc9c71233c88981a1f79fe6503a64998a668f5e'
AND (
token = 'gdlXKYl/5vqAhrRwC6neR5XvyKSrcehRhp92D0Kbuc4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)