UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H9AJ/6Hlwcan9h1XZcXxutXYvPx8iB+Sq+xXu4tFAd8='
WHERE
key_id = 'b677a87f650cfbc4f2906454ea41d0dada7f742e89794da69a750c22772a9c98'
AND (
token = 'H9AJ/6Hlwcan9h1XZcXxutXYvPx8iB+Sq+xXu4tFAd8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)