UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hSUKgOSXBtDhRHQvUl7sh7CNkOkpYpTlDsHKGu3youE='
WHERE
key_id = '9f3e3917e75823a7dbc25bf8647be955b57bac3c5423c02981ff5a354a5bd8b9'
AND (
token = 'hSUKgOSXBtDhRHQvUl7sh7CNkOkpYpTlDsHKGu3youE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)