UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '4e79z/liWn7WWG2RnHwkydmwI/wY1+xlgqqK56HdqCc=' 
WHERE 
  key_id = 'b698feae5b5db9fdf5dd31a3e7e49ccd8bafc0abe89d1ad1f824417dfede41f9' 
  AND (
    token = '4e79z/liWn7WWG2RnHwkydmwI/wY1+xlgqqK56HdqCc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034