UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1BCMZd7aD9rMSObVfjdtrG7i/czSwjN9y6NLhbbG5zg='
WHERE
key_id = 'd2046996e4304a4fd385a57007f6593eb02d42730fa0d5ac80b5b591cf791d50'
AND (
token = '1BCMZd7aD9rMSObVfjdtrG7i/czSwjN9y6NLhbbG5zg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)