UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'EhUD3h8xi/4MUS6PQeM3s3p/3o9MBKE+7sW/Fo49owA=' 
WHERE 
  key_id = '7e764376d6fb7ed7aae95bcadd1f5c2e5ae2712c82148236b65cd0c75084360b' 
  AND (
    token = 'EhUD3h8xi/4MUS6PQeM3s3p/3o9MBKE+7sW/Fo49owA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00037