UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3Xw7waSvFZBobqu+OOSgVNj8LitrMVx8IGaUMpVjoGw='
WHERE
key_id = '0b718afee87aaa3f79bdbd5e27ea618b4e4acd9280de076e3e5cfa415251a6e5'
AND (
token = '3Xw7waSvFZBobqu+OOSgVNj8LitrMVx8IGaUMpVjoGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)