UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'iNl9jLiciSvJjnZp8JZlc359KpPHg/+1hG4Mkgmr3eU='
WHERE
key_id = '82336b52854c67b19edfb9c5f09c22a60c6f5b8930b30fcaa9f098b96147695d'
AND (
token = 'iNl9jLiciSvJjnZp8JZlc359KpPHg/+1hG4Mkgmr3eU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)