UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'coFzIkXgLEWOhDoBvc2NDJgB32LUfC7fAQU4qd9fUII='
WHERE
key_id = '5067b68e88f11147f820313169c6c08f2881e75cd81ec7e3190710796ef81e64'
AND (
token = 'coFzIkXgLEWOhDoBvc2NDJgB32LUfC7fAQU4qd9fUII='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)