UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5X0yRcdiQFz9YN9RNr9sAIOHxzecFqtyLuS3MUenxyU='
WHERE
key_id = '2d6a1226b1ac5879d8999edb3d42391b3a8dd4db1a4bb231ddea92d9cd715b75'
AND (
token = '5X0yRcdiQFz9YN9RNr9sAIOHxzecFqtyLuS3MUenxyU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)