UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/jv14a3PP2Fuw+3waS/wnBMvfDMmIOFq/CD+9QevI+4='
WHERE
key_id = '900e5e7200e495a401cf32205cc3b1d19b212c08136f094de25c9f90b87442a7'
AND (
token = '/jv14a3PP2Fuw+3waS/wnBMvfDMmIOFq/CD+9QevI+4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)