UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'opDrU+C8Xvg3RzN2Bgug1budtZgo7O9SOWKMZee5N7s='
WHERE
key_id = 'b333e5788d4c900a3b8c131b8604e5cfcda6b7a4e989beb496e39d8ba7b6df98'
AND (
token = 'opDrU+C8Xvg3RzN2Bgug1budtZgo7O9SOWKMZee5N7s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)