UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7jRHy1vlvR8YUJPpBQ2F9Ig8Bcwih6FhDKrokK5VfgY='
WHERE
key_id = '4de224e01830b5abf189d4156d7f73b2f90ef7ee397f9e1f0577c893263f8d9e'
AND (
token = '7jRHy1vlvR8YUJPpBQ2F9Ig8Bcwih6FhDKrokK5VfgY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)