UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XTsY9JWCVdfWxCMZFaRBnVnuiJ5sZ55w7eeIGsy9f68='
WHERE
key_id = 'c20e387762e1a8d4ed43f7d1d7e78ef32c62958811100f43c71c018987727502'
AND (
token = 'XTsY9JWCVdfWxCMZFaRBnVnuiJ5sZ55w7eeIGsy9f68='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)