UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CT78aZN1XbazzvQvs6Ti3ryZBoJYrqkbrI6NpqCO7Og='
WHERE
key_id = '45502d3ce394e4c743443ffed5d56207a5210ed7dccf149ef92850b5db81146c'
AND (
token = 'CT78aZN1XbazzvQvs6Ti3ryZBoJYrqkbrI6NpqCO7Og='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)