UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '5K4V8l+TWOCSK1WXPBkzmAE1ZXcxlKz8h63v5dTR3ZU=' 
WHERE 
  key_id = 'a049b0129f24b64b226876b5520c1c7c5625227ced0899ac21be7327d92f897b' 
  AND (
    token = '5K4V8l+TWOCSK1WXPBkzmAE1ZXcxlKz8h63v5dTR3ZU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00052