UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dZ2/6sK1jUHnXX2KWw8YDxELUazD5AQLkSRTT4Xbrsg='
WHERE
key_id = '9ef8d0154d7cc0d29939f67c566327e17e3b13968f2083291453ab67d1b9cc4a'
AND (
token = 'dZ2/6sK1jUHnXX2KWw8YDxELUazD5AQLkSRTT4Xbrsg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)