UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qY96ZIaO1ABdBF4NbzdoefbejH1weA5D0huoxkZLqWw='
WHERE
key_id = 'e418dc1c1418bce2ac6fb0f6e0187f042b1c2de3b9730409214f1fdb1cacce1c'
AND (
token = 'qY96ZIaO1ABdBF4NbzdoefbejH1weA5D0huoxkZLqWw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)