UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zg/NmPnsKz6SCm5bYNzwXhdR5pa4APsqIIV5CPuGxa4='
WHERE
key_id = 'a7a21b1759e6d7d05f23b568bd603a5dfd42f4b4127206ba910cc96b30318ba4'
AND (
token = 'zg/NmPnsKz6SCm5bYNzwXhdR5pa4APsqIIV5CPuGxa4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)