UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/3a6aZJbPnoGR51GPr9OHgx9vyGY8O726RKCB8bZQXY='
WHERE
key_id = 'e65f97228da84a45a54417472f4ee85bebdeed9fcafd63449331c23a8a3376b9'
AND (
token = '/3a6aZJbPnoGR51GPr9OHgx9vyGY8O726RKCB8bZQXY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)