UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'j7vZpcjF5L5CLqFlm71+KhDrHzP7h3QfwsBLw0+0BWc=' 
WHERE 
  key_id = '52b3ae00816ed47993768bf0d7e2e65a318f7a3bad5ad2cf3b98c75472dc1780' 
  AND (
    token = 'j7vZpcjF5L5CLqFlm71+KhDrHzP7h3QfwsBLw0+0BWc=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021