UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'xRMAE6Ddb3zuv3j5QjI2tMSKZWNMkuBMziT3rVhKfbY=' 
WHERE 
  key_id = 'ee28037eee96b9167815a8ddaa2b34f484fe790f7704f6ea77bd8b21bc69249d' 
  AND (
    token = 'xRMAE6Ddb3zuv3j5QjI2tMSKZWNMkuBMziT3rVhKfbY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022