UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8JHI6eKICDoHAQlJ63brlN0AuXN1rsjAFE0bySXKsNo='
WHERE
key_id = 'e0be6aa1b44ad10f9e7109ba26a922cd2b89aa7ddee01dcb7af75217483a9e5c'
AND (
token = '8JHI6eKICDoHAQlJ63brlN0AuXN1rsjAFE0bySXKsNo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)