UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '7h4WC1amStfVo5xb5LECy+ZXwO8b/nU+osoFg+mkHqc=' 
WHERE 
  key_id = '8230cbd1b5a9beb1d0e885a1fe155d063f6b23a4c85725e42d8d953987fe8d96' 
  AND (
    token = '7h4WC1amStfVo5xb5LECy+ZXwO8b/nU+osoFg+mkHqc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00040