UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '7fJlm73DL8tf7/ORZyfNSFbndmZqsaDUZqModICaJSU=' 
WHERE 
  key_id = '4d16fdb45c071d9d31454f190262881a7080a52739bed7e56fdf1e1e2e8cb7ec' 
  AND (
    token = '7fJlm73DL8tf7/ORZyfNSFbndmZqsaDUZqModICaJSU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00044