UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8bXy+UK0tlBF6GYmnCPHnx9uGBsFYrCdf8QNRDUgcb8='
WHERE
key_id = '1a9ea30f66ef3128b6874cca9601bf5d6a8eb685404e6e28c510deccff0e2a70'
AND (
token = '8bXy+UK0tlBF6GYmnCPHnx9uGBsFYrCdf8QNRDUgcb8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)