UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RY/8VSSS4Q980z3kC14GAaiKtyzU8AJyJwCFbFN1dzs='
WHERE
key_id = 'f0a434f4c454b0a14f96bb4a9fc0fa7212cf54314f3ebcf1a7cbe52ab614f700'
AND (
token = 'RY/8VSSS4Q980z3kC14GAaiKtyzU8AJyJwCFbFN1dzs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)