UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6/x4NRyqJdwEl06NmBS1TluEzxIyStfkmF49Fx2CwXo='
WHERE
key_id = '7779534e37344b88b6464d224fa6ea1626600e85f1f034242cfaab231a38397a'
AND (
token = '6/x4NRyqJdwEl06NmBS1TluEzxIyStfkmF49Fx2CwXo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)