UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LNnYzlKMpJzlm5voPsKNJ06AsIizMfj3wYyg0OxsjdI='
WHERE
key_id = 'f3c9dd9e923767ccd5b60b0ec23ad4536b4bfca69c1fdf4f5b660e98d051f6fd'
AND (
token = 'LNnYzlKMpJzlm5voPsKNJ06AsIizMfj3wYyg0OxsjdI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)